const User = require('../model/user.model')
class UserService {
    async createUser(user_name, password) {
        // 插入数据
        // await 表达式：promise对象的值
        console.log('——创建用户——')
        const res = await User.create({
            // 表的字段：传过来的值
            // 字段相同时可简写，ES语法
            user_name,
            password
        })
        return res.dataValues
    };

    async getUserInfo({ id, user_name, password, is_admin }) {
        const whereOpt = {}
        id && Object.assign(whereOpt, { id })
        user_name && Object.assign(whereOpt, { user_name })
        password && Object.assign(whereOpt, { password })
        is_admin && Object.assign(whereOpt, { is_admin })

        const res = await User.findOne({
            attributes: ['id', 'user_name', 'password', 'is_admin'],
            where: whereOpt
        })
        return res ? res.dataValues : null
    };

    async updateById({ id, user_name, password, is_admin }) {
        const whereOpt = { id }
        const newUser = {}

        user_name && Object.assign(newUser, { user_name })
        password && Object.assign(newUser, { password })
        is_admin && Object.assign(newUser, { is_admin })

        const res = await User.update(newUser, { where: whereOpt })
        return res[0] > 0 ? true : false
    }
}

module.exports = new UserService()